import xlrd
class Excel:
    def h(self):
        table = xlrd.open_workbook('C:\\Users\\Administrator\\Desktop\\TinyShop_2.4.xlsx')
        data = table.sheet_by_index(0)
        list = []
        for i in range(1,data.nrows):
            info = data.row_values(i)
            a = info[1]
            b = info[2]
            c = info[4]
            d = info[3]
            e = d.split(',')
            f = a,b,e,c
            list.append(f)
        # print(list)
        return list
    def hu(self):
        a = Excel().h()
        list = []
        for i in a:
            a = i[0]
            b= i[1]
            c = i[2]
            d = i[3]
            list1 = []
            for j in range(len(c)):
                e = c[j].split('=')[1]
                list1.append(e)
                f = a,b,list1,d
            list.append(f)
        # print(list)
        return list
Excel().h()
Excel().hu()